Use DXL to query an ORACLE table/view

Hi All,

Ok. Another difficult question.
I have already setup my ODBC to access my Oracle DB's.
I am using the Oracle ODBC driver.
I want to use DXL to go out and read a table/view and bring back data that I can
use to populate user information.
From my searching, I see that this is not going to be easy if at all possible.
I hope one of you guys has a positive answer - as in "yes this can be done, and here is how".
Thanks.
Jerry
SystemAdmin - Fri Sep 02 16:02:04 EDT 2011

Re: Use DXL to query an ORACLE table/view
OurGuest - Sun Sep 04 18:58:01 EDT 2011

If I recall, microsoft has a ODBC driver that will let you connect from DOORS to Oracle that is free of charge.

Re: Use DXL to query an ORACLE table/view
Mathias Mamsch - Mon Sep 05 09:00:17 EDT 2011

See here for an example on making a SQL query over odbc from DXL:

https://www.ibm.com/developerworks/forums/thread.jspa?messageID=14551111&#14551111

Regards, Mathias


Mathias Mamsch, IT-QBase GmbH, Consultant for Requirement Engineering and D00RS